<?php
$q=$_GET["q"];

$link = mysql_connect('cash2uca.ipagemysql.com', 'cash2uca', 'actW3740!@#$'); 
if (!$link) { 
    die('Could not connect: ' . mysql_error()); 
	} 
mysql_select_db(cash2uca);
$strSQL = "SELECT * FROM Applications WHERE AccountID = '".$q."'";
$rs = mysql_query($strSQL);
echo "<table cellspacing='4' cellpadding='1' border='0' style='margin: 0 0 0 0;'>
<tr>
<th>AccountID</th>
<th>Loan Amount</th>
<th>Loan Cost</th>
<th>First PayDay</th>
<th>Visit Times</th>
</tr>";

while($row = mysql_fetch_array($rs))
  {
  echo "<tr>";
  echo "<td>" . $row['AccountID'] . "</td>";
  echo "<td>" . $row['BAmount'] . "</td>";
  echo "<td>" . $row['Costs'] . "</td>";
  echo "<td>" . $row['FirstPayDay'] . "</td>";
  echo "<td>" . $row['NumberofVisits'] . "</td>";
  echo "</tr>";
  }
echo "</table>";

mysql_close($link);
?>













































